Sales Order Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
CustLevel nvarchar 10      
Descr nvarchar 35      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CostExt pDecimal 13      
Counter int 4      
CustId pCustID 10      
EntryDate datetime 8      
EntryNum int 4      
ExtLocA int 4      
ExtLocAId varchar 10      
ExtLocB int 4      
ExtLocBId varchar 10      
FiscalYear smallint 2      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
GlPeriod smallint 2      
ItemDescr varchar 35      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
Notes nvarchar max      
PostDate datetime 8      
PostRun pPostRun 14      
PriceExt pDecimal 13      
QtyReturn pDecimal 13      
ResCode varchar 10      
ResCodeDescr varchar 35      
RMANumber pInvoiceNum 15      
SerNum pSerNum 35      
Status tinyint 1   Status 0 = Approved, 1 = New, 9 = Posted
TransDate datetime 8      
TransId pTransID 8      
UnitCost pDecimal 13      
UnitPrice pDecimal 13      
Units pUom 5      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
ItemId pItemID 24      
LocId pLocID 10      
CustLevel nvarchar 10      
Descr nvarchar 35      
PriceAdjBase tinyint 1 0 Price Adjustment Basis 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjAmt pDecimal 13 0    
PriceAdjPromoYn bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
HeaderId bigint        
CustId pCustID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SeqNum bigint        
HeaderId bigint        
BreakAmount pDecimal 13 0    
BreakUOM pUom        
AdjustmentBase tinyint        
AdjustmentType tinyint        
AdjustmentAmount pDecimal 13 0    
ItemId pItemID 24      
LocId pLocID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
ContractPriceId nvarchar 10      
Description nvarchar 35      
PriceBreakType smallint        
StartDate datetime 8      
EndDate datetime 8      
CustomerFilter nvarchar max      
ItemFilter nvarchar max      
PerItemPricingYN bit 1 0    
CustomerFilterSql nvarchar max      
ItemFilterSql nvarchar max      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
HeaderId bigint        
ItemId pItemID 24      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PromoId nvarchar 10      
Descr nvarchar 35      
PriceIdFrom nvarchar 10      
PriceIdThru nvarchar 10      
CustLevelFrom nvarchar 10      
CustLevelThru nvarchar 10      
ProductLineFrom nvarchar 12      
ProductLineThru nvarchar 12      
ItemIdFrom pItemID 24      
ItemIdThru pItemID 24      
UomFrom pUom 5      
UomThru pUom 5      
LocIdFrom pLocID 10      
LocIdThru pLocID 10      
UsrFld1From nvarchar 12      
UsrFld1Thru nvarchar 12      
UsrFld2From nvarchar 12      
UsrFld2Thru nvarchar 12      
PriceAdjBase tinyint 1 0 Price Adjustment Basis 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjAmt pDecimal 13 0    
DateStart datetime 8      
DateEnd datetime 8      
WebOnlyYn bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PriceId nvarchar 10      
CustLevel nvarchar 10      
Descr nvarchar 35      
PriceAdjBase tinyint 1 0 Price Adjustment Basis 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjAmt pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PriceId nvarchar 10      
Descr nvarchar 35      
DfltAdjBase tinyint 1 0 Default Price Adjustment Basis 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price
DfltAdjType tinyint 1 0 Default Price Adjustment Type 0 = Amount, 1 = Percent
DfltAdjAmt pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ResCode nvarchar 10      
Descr nvarchar 35      
ActiveYN bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
Status tinyint 1 -1 Returned Item Status 0 = Approved, 1 = New, 9 = Posted
ResCode nvarchar 10      
RMANumber pInvoiceNum 15      
CustID pCustID 10      
TransId pTransID 8      
EntryNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
ExtLocA int 4      
ExtLocAID nvarchar 10      
ExtLocB int 4      
ExtLocBID nvarchar 10      
EntryDate datetime 8      
TransDate datetime 8      
Units pUom 5      
QtyReturn pDecimal 13 0    
LotNum pLotNum 16      
SerNum pSerNum 35      
UnitCost pDecimal 13 0    
CostExt pDecimal 13 0    
UnitPrice pDecimal 13 0    
PriceExt pDecimal 13 0    
QtySeqNum int 4 0    
QtySeqNumExt int 4 0    
HistSeqNum int 4 0    
HistSeqNumSer int 4 0    
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
Notes text 16      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BlanketRef int 4      
BatchId pBatchID 6      
BlanketId pTransID 8      
ExpireDate datetime 8      
CloseDate datetime 8      
ContractDate datetime 8 getdate()    
ContractAmount pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
Subtotal pDecimal 13      
LocId pLocID 10      
CustLevel nvarchar 10      
DistCode pDistCode 6      
SoldToId pCustID 10      
CustId pCustID 10      
TermsCode pTermsCode 6      
TaxableYN bit 1 -1    
TaxOnFreight bit 1 -1    
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
PODate datetime 8 getdate()    
CustPONum nvarchar 25      
ShipToId pCustID 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
ShipToPhone nvarchar 24      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
CurrencyId pCurrency 6      
Notes nvarchar max      
ShipToId pCustID 10      
TaxGrpId pTaxLoc 10      
BlanketStatus smallint 1 0 Blanket Status 0 = Open, 1 = On Hold, 2 = Closed
BlanketType smallint 1 0 Blanket Type 0 = Amount, 1 = On Demand, 2 = Scheduled
ts timestamp 8      
CF xml -1      
*TaxGrpId2 pTaxLoc        
*FreightTermID bigint        
*FreightAccountNumber nvarchar 255      
*DeliverySurcharge bit 1 0    
*ResidentialYN bit 1 0    
*GlobalLocationNumber nvarchar 13      
Column Name Column Type Length Default Value Description Enumeration
BlanketDtlRef int 4      
BlanketRef int 4      
EntryDate datetime 8      
Id int 4      
PostRun pPostRun 14      
PriceExt pDecimal 13      
Qty pDecimal 13      
RecType smallint 2   Record Type 1 = Line Item, 2 = Freight, 3 = Misc
TransDate datetime 8      
TransId pTransID 8      
TransType smallint 2   Transaction Type 1 = Release, -1 = Credit
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BlanketDtlRef int 4      
BlanketRef int 4      
EntryDate datetime 8      
Id int 4      
LineSeq int 4      
LocId pLocID 10      
ItemId pItemID 24      
CatId nvarchar 2      
TaxClass tinyint 1 0    
AcctCode pGLAcctCode 2      
GLAcctSales pGlAcct 40      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
LotNum pLotNum 16      
PostRun pPostRun 14      
PriceExt pDecimal 13 0    
Qty pDecimal 13      
QtyOrdered pDecimal 13 0    
QtyReleased pDecimal 13 0    
Units pUom 5      
UnitPrice pDecimal 13 0    
UnitCost pDecimal 13 0    
CostExt pDecimal 13 0    
RecType smallint 2   Record Type 1 = Line Item, 2 = Freight, 3 = Misc
GrpId int 4      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
UnitCommBasis pDecimal 13 0    
TransDate datetime 8      
TransId pTransID 8      
TransType smallint 2   Transaction Type 1 = Release, -1 = Credit
ts timestamp 8      
AddnlDescr nvarchar max      
Descr pDescription 255      
PriceId pTaxLoc 10      
PromoId pTaxLoc 10      
CustomerPartNumber pDescription        
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BlanketDtlRef int 4      
BlanketDtlSchRef int 4      
ReleaseDate datetime 8      
QtyOrdered pDecimal 13 0    
ts timestamp 8      
CF xml -1      
Status tinyint 1 0 Blanket Order Status 0 = New, 1 = Released, 2 = On Hold
Column Name Column Type Length Default Value Description Enumeration
TransID pTransID 8      
EntryNum int 4      
ItemJob tinyint 1 0 Item / Job Flag 0 = Item, 1 = Job
LocId pLocID 10      
ItemId pItemID 24      
JobId nvarchar 10      
PhaseId nvarchar 10      
JobCompleteYN bit 1 0    
ItemType tinyint 1 0 Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
Descr nvarchar 35      
AddnlDescr text 16      
CatId nvarchar 2      
TaxClass tinyint 1 0    
AcctCode pGLAcctCode 2      
GLAcctSales pGlAcct 40      
GLAcctCOGS pGlAcct 40      
GLAcctInv pGlAcct 40      
QtyOrdSell pDecimal 13 0    
UnitsSell pUom 5      
UnitsBase pUom 5      
QtyShipSell pDecimal 13 0    
QtyShipBase pDecimal 13 0    
QtyBackordSell pDecimal 13 0    
PriceID nvarchar 10      
UnitPriceSell pDecimal 13 0    
UnitPriceSellFgn pDecimal 13 0    
UnitCostSell pDecimal 13 0    
UnitCostSellFgn pDecimal 13 0    
PriceExt pDecimal 13 0    
PriceExtFgn pDecimal 13 0    
CostExtFgn pDecimal 13 0    
CostExt pDecimal 13 0    
PromoID nvarchar 10      
ReqShipDate datetime 8      
ActShipDate datetime 8      
EffectiveRate pDecimal 13 0    
OrigOrderQty pDecimal 13 0    
BinNum nvarchar 10      
ConversionFactor pDecimal 13 -1    
LottedYN bit 1 0    
InItemYN bit 1 -1    
HistSeqNum int 4 0    
GrpId int 4      
Kit bit 1 0    
KitQty pDecimal 13 -1    
KitQtyBackOrdered pDecimal 13 0    
OriCompQty pDecimal 13 0    
QtySeqNum_Cmtd int 4 0    
QtySeqNum int 4 0    
LineSeq int 4      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep1CommRate pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
UnitCommBasis pDecimal 13 0    
UnitCommBasisFgn pDecimal 13 0    
PriceAdjType tinyint 1 0 Price Adjustment Type 0 = Amount, 1 = Percent
PriceAdjPct pDecimal 13 0    
PriceAdjAmt pDecimal 13 0    
PriceAdjAmtFgn pDecimal 13 0    
Status tinyint 1 0 Line Item Status 0 = Open, 1 = Completed
TotQtyOrdSell pDecimal 13 0    
TotQtyShipSell pDecimal 13 0    
ResCode nvarchar 10      
UnitPriceSellBasis pDecimal 13 0    
UnitPriceSellBasisFgn pDecimal 13 0    
BlanketDtlRef int 4      
BOLNum nvarchar 17      
LinkSeqNum int 4      
CustomerPartNumber pDescription        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Cmnt nvarchar 35      
CostUnit pDecimal 13      
CostUnitFgn pDecimal 13      
EntryNum int 4      
ExtLocA int 4      
ExtLocB int 4      
HistSeqNum int 4      
LotNum pLotNum 16      
QtyFilled pDecimal 13      
QtyOrder pDecimal 13      
QtySeqNum int 4      
QtySeqNum_Cmtd int 4      
QtySeqNum_Ext int 4      
SeqNum int 4      
TransId pTransID 8      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
TransType smallint 2 -9 Transaction Type 1 = Invoice, 2 = Price Quote, 3 = Backordered, 4 = Verified, 5 = Picked, 8 = Void Sales, 9 = New, -1 = Credit Memo, -2 = RMA, -8 = Void Returns (1 = Sales, -1 = Returns)
VoidYn bit 1 0    
BatchId pBatchID 6 '######'    
LocId pLocID 10      
CustId pCustID 10      
CustLevel nvarchar 10      
ShipToID pCustID 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipVia nvarchar 20      
TermsCode pTermsCode 6      
DistCode pDistCode 6      
InvcNum pInvoiceNum 15      
OrgInvcNum pInvoiceNum 15      
-*OrgInvcExchRate pDecimal 13 -1    
InvcDate datetime 8 getdate()    
TransDate datetime 8 getdate()    
PODate datetime 8 getdate()    
CustPONum nvarchar 25      
ShipNum nvarchar 18      
ReqShipDate datetime 8 getdate()    
ActShipDate datetime 8      
Rep1Id pSalesRep 3      
Rep1Pct pDecimal 13 0    
Rep2Id pSalesRep 3      
Rep2Pct pDecimal 13 0    
TaxableYN bit 1 -1    
TaxOnFreight bit 1 -1    
TaxClassFreight tinyint 1 0    
TaxClassMisc tinyint 1 0    
TaxGrpID pTaxLoc 10      
TaxableSales pDecimal 13 0    
NonTaxableSales pDecimal 13 0    
SalesTax pDecimal 13 0    
Freight pDecimal 13 0    
Misc pDecimal 13 0    
TotCost pDecimal 13 0    
CurrencyID pCurrency 6      
ExchRate pDecimal 13 -1    
-*CalcGainLoss pDecimal 13 0    
PickNum pInvoiceNum 15      
PrintAcknowStatus tinyint 1 0 Order Acknowledgement Print Status 0 = Unprinted, 1 = Online, 2 = Batch
PrintPackStatus tinyint 1 0 Packing List Print Status 0 = Unprinted, 1 = Online, 2 = Batch
PackNum pInvoiceNum 15      
PostDate datetime 8      
GLPeriod smallint 2 0    
FiscalYear smallint 2 0    
-*SumHistPeriod smallint 2 -1    
PrintInvcStatus tinyint 1 0 Invoice Print Status 0 = Unprinted, 1 = Online, 2 = Batch
PrintPickStatus tinyint 1 0 Picking Slip Print Status 0 = Unprinted, 1 = Online, 2 = Batch, 4 = WM Generated
NetDueDate datetime 8      
DiscDueDate datetime 8      
DiscAmt pDecimal 13 0    
DiscAmtFgn pDecimal 13 0    
TaxAmtAdj pDecimal 13 0    
TaxAdj tinyint 1 -1    
TaxLocAdj pTaxLoc 10      
TaxClassAdj tinyint 1 0    
TaxableSalesFgn pDecimal 13 0    
NonTaxableSalesFgn pDecimal 13 0    
SalesTaxFgn pDecimal 13 0    
FreightFgn pDecimal 13 0    
MiscFgn pDecimal 13 0    
TotCostFgn pDecimal 13 0    
TaxAmtAdjFgn pDecimal 13 0    
Layaway bit 1 0    
ShipToPhone nvarchar 24      
Notes text 16      
Rep1CommRate pDecimal 13 0    
Rep2CommRate pDecimal 13 0    
SoldToId pCustID 10      
BlanketRef int 4      
SourceId uniqueidentifier 16 newid()    
CF xml -1      
ts timestamp 8      
*OrgInvoiceID int 4      
*TaxGrpId2 pTaxLoc        
*FreightTermID bigint        
*FreightAccountNumber nvarchar 255      
*DeliverySurcharge bit 1 0    
*ResidentialYN bit 1 0    
*GlobalLocationNumber nvarchar 13      
*TotalCharges pDecimal 13 0    
*ActualWeight pDecimal 13 0    
*ShipToFax nvarchar 15      
*ShipToEmail pEmail        
*NumberOfPackage Int 4      
*ReqDeliveryDate datetime 8      
Column Name Column Type Length Default Value Description Enumeration
PmtNum int 4      
PmtDate datetime 8 getdate()    
TransId pTransID 8      
DepositId pBatchID 6      
LinkId int 4      
PmtMethodId nvarchar 10      
CcNum nvarchar 510      
CcHolder nvarchar 30      
CcExpire datetime 8      
CcAuth nvarchar 10      
CheckNum pCheckNum 10      
Note nvarchar 25      
PmtAmt pDecimal 13 0    
PmtAmtFgn pDecimal 13 0    
CurrencyId pCurrency 6      
ExchRate pDecimal 13 -1    
CalcGainLoss pDecimal 13 0    
PostedYn bit 1 0    
CcSecCode nvarchar 6      
BankName nvarchar 30      
BankRoutingCode nvarchar 9      
BankAcctNum nvarchar 510      
GlPeriod smallint 2 -1    
FiscalYear smallint 2 0    
GlAcctReceivables pGlAcct 40      
GlAcctGainLoss pGlAcct 40      
CF xml -1      
ts timestamp 8      
ExtPmtActivityID bigint 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnit pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4 0    
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
*CostUnitACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
TaxLocID pTaxLoc 10      
TaxClass tinyint 1 0    
Level tinyint 1 -1    
TaxAmt pDecimal 13 0    
TaxAmtFgn pDecimal 13 0    
Taxable pDecimal 13 0    
TaxableFgn pDecimal 13 0    
NonTaxable pDecimal 13 0    
NonTaxableFgn pDecimal 13 0    
LiabilityAcct pGlAcct 40      
CF xml -1      
ts timestamp 8      
TaxGroupType tinyint 1 0   0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2
ExpenseAccount pGlAcct